using System; 
using System.Text; 
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration; 
using System.Xml; 
using System.Xml.Serialization;
using SubSonic; 
using SubSonic.Utilities;

namespace Adex{
    /// <summary>
    /// Strongly-typed collection for the VInternetLog class.
    /// </summary>
    [Serializable]
    public partial class VInternetLogCollection : ReadOnlyList<VInternetLog, VInternetLogCollection>
    {        
        public VInternetLogCollection() {}

    }

    /// <summary>
    /// This is  Read-only wrapper class for the vInternetLog view.
    /// </summary>
    [Serializable]
    public partial class VInternetLog : ReadOnlyRecord<VInternetLog> 
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }

	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }

                return BaseSchema;
            }

        }

    	
        private static void GetTableSchema() 
        {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("vInternetLog", TableType.View, DataService.GetInstance("Adex"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = "dbo";
                //columns
                
                TableSchema.TableColumn colvarMediaTypeName = new TableSchema.TableColumn(schema);
                colvarMediaTypeName.ColumnName = "MediaTypeName";
                colvarMediaTypeName.DataType = DbType.String;
                colvarMediaTypeName.MaxLength = 50;
                colvarMediaTypeName.AutoIncrement = false;
                colvarMediaTypeName.IsNullable = true;
                colvarMediaTypeName.IsPrimaryKey = false;
                colvarMediaTypeName.IsForeignKey = false;
                colvarMediaTypeName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaTypeName);
                
                TableSchema.TableColumn colvarMediaName = new TableSchema.TableColumn(schema);
                colvarMediaName.ColumnName = "MediaName";
                colvarMediaName.DataType = DbType.String;
                colvarMediaName.MaxLength = 255;
                colvarMediaName.AutoIncrement = false;
                colvarMediaName.IsNullable = true;
                colvarMediaName.IsPrimaryKey = false;
                colvarMediaName.IsForeignKey = false;
                colvarMediaName.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaName);
                
                TableSchema.TableColumn colvarMediaType = new TableSchema.TableColumn(schema);
                colvarMediaType.ColumnName = "MediaTypeCode";
                colvarMediaType.DataType = DbType.Int32;
                colvarMediaType.MaxLength = 0;
                colvarMediaType.AutoIncrement = false;
                colvarMediaType.IsNullable = true;
                colvarMediaType.IsPrimaryKey = false;
                colvarMediaType.IsForeignKey = false;
                colvarMediaType.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaType);
                
                TableSchema.TableColumn colvarInternetLogID = new TableSchema.TableColumn(schema);
                colvarInternetLogID.ColumnName = "InternetLogID";
                colvarInternetLogID.DataType = DbType.Int32;
                colvarInternetLogID.MaxLength = 0;
                colvarInternetLogID.AutoIncrement = false;
                colvarInternetLogID.IsNullable = false;
                colvarInternetLogID.IsPrimaryKey = false;
                colvarInternetLogID.IsForeignKey = false;
                colvarInternetLogID.IsReadOnly = false;
                
                schema.Columns.Add(colvarInternetLogID);
                
                TableSchema.TableColumn colvarCountryID = new TableSchema.TableColumn(schema);
                colvarCountryID.ColumnName = "CountryID";
                colvarCountryID.DataType = DbType.Byte;
                colvarCountryID.MaxLength = 0;
                colvarCountryID.AutoIncrement = false;
                colvarCountryID.IsNullable = true;
                colvarCountryID.IsPrimaryKey = false;
                colvarCountryID.IsForeignKey = false;
                colvarCountryID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCountryID);
                
                TableSchema.TableColumn colvarRFDate = new TableSchema.TableColumn(schema);
                colvarRFDate.ColumnName = "RFDate";
                colvarRFDate.DataType = DbType.DateTime;
                colvarRFDate.MaxLength = 0;
                colvarRFDate.AutoIncrement = false;
                colvarRFDate.IsNullable = true;
                colvarRFDate.IsPrimaryKey = false;
                colvarRFDate.IsForeignKey = false;
                colvarRFDate.IsReadOnly = false;
                
                schema.Columns.Add(colvarRFDate);
                
                TableSchema.TableColumn colvarMediaCode = new TableSchema.TableColumn(schema);
                colvarMediaCode.ColumnName = "MediaCode";
                colvarMediaCode.DataType = DbType.Int32;
                colvarMediaCode.MaxLength = 0;
                colvarMediaCode.AutoIncrement = false;
                colvarMediaCode.IsNullable = true;
                colvarMediaCode.IsPrimaryKey = false;
                colvarMediaCode.IsForeignKey = false;
                colvarMediaCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarMediaCode);
                
                TableSchema.TableColumn colvarTimeStart = new TableSchema.TableColumn(schema);
                colvarTimeStart.ColumnName = "TimeStart";
                colvarTimeStart.DataType = DbType.Int32;
                colvarTimeStart.MaxLength = 0;
                colvarTimeStart.AutoIncrement = false;
                colvarTimeStart.IsNullable = true;
                colvarTimeStart.IsPrimaryKey = false;
                colvarTimeStart.IsForeignKey = false;
                colvarTimeStart.IsReadOnly = false;
                
                schema.Columns.Add(colvarTimeStart);
                
                TableSchema.TableColumn colvarTimeEnd = new TableSchema.TableColumn(schema);
                colvarTimeEnd.ColumnName = "TimeEnd";
                colvarTimeEnd.DataType = DbType.Int32;
                colvarTimeEnd.MaxLength = 0;
                colvarTimeEnd.AutoIncrement = false;
                colvarTimeEnd.IsNullable = true;
                colvarTimeEnd.IsPrimaryKey = false;
                colvarTimeEnd.IsForeignKey = false;
                colvarTimeEnd.IsReadOnly = false;
                
                schema.Columns.Add(colvarTimeEnd);
                
                TableSchema.TableColumn colvarPageNumber = new TableSchema.TableColumn(schema);
                colvarPageNumber.ColumnName = "PageNumber";
                colvarPageNumber.DataType = DbType.Int32;
                colvarPageNumber.MaxLength = 0;
                colvarPageNumber.AutoIncrement = false;
                colvarPageNumber.IsNullable = true;
                colvarPageNumber.IsPrimaryKey = false;
                colvarPageNumber.IsForeignKey = false;
                colvarPageNumber.IsReadOnly = false;
                
                schema.Columns.Add(colvarPageNumber);
                
                TableSchema.TableColumn colvarInternetBodyCode = new TableSchema.TableColumn(schema);
                colvarInternetBodyCode.ColumnName = "InternetBodyCode";
                colvarInternetBodyCode.DataType = DbType.Int32;
                colvarInternetBodyCode.MaxLength = 0;
                colvarInternetBodyCode.AutoIncrement = false;
                colvarInternetBodyCode.IsNullable = true;
                colvarInternetBodyCode.IsPrimaryKey = false;
                colvarInternetBodyCode.IsForeignKey = false;
                colvarInternetBodyCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarInternetBodyCode);
                
                TableSchema.TableColumn colvarTipology = new TableSchema.TableColumn(schema);
                colvarTipology.ColumnName = "Tipology";
                colvarTipology.DataType = DbType.String;
                colvarTipology.MaxLength = 5;
                colvarTipology.AutoIncrement = false;
                colvarTipology.IsNullable = true;
                colvarTipology.IsPrimaryKey = false;
                colvarTipology.IsForeignKey = false;
                colvarTipology.IsReadOnly = false;
                
                schema.Columns.Add(colvarTipology);
                
                TableSchema.TableColumn colvarRealCost = new TableSchema.TableColumn(schema);
                colvarRealCost.ColumnName = "RealCost";
                colvarRealCost.DataType = DbType.Currency;
                colvarRealCost.MaxLength = 0;
                colvarRealCost.AutoIncrement = false;
                colvarRealCost.IsNullable = true;
                colvarRealCost.IsPrimaryKey = false;
                colvarRealCost.IsForeignKey = false;
                colvarRealCost.IsReadOnly = false;
                
                schema.Columns.Add(colvarRealCost);
                
                TableSchema.TableColumn colvarWide = new TableSchema.TableColumn(schema);
                colvarWide.ColumnName = "Wide";
                colvarWide.DataType = DbType.Double;
                colvarWide.MaxLength = 0;
                colvarWide.AutoIncrement = false;
                colvarWide.IsNullable = true;
                colvarWide.IsPrimaryKey = false;
                colvarWide.IsForeignKey = false;
                colvarWide.IsReadOnly = false;
                
                schema.Columns.Add(colvarWide);
                
                TableSchema.TableColumn colvarPageType = new TableSchema.TableColumn(schema);
                colvarPageType.ColumnName = "PageType";
                colvarPageType.DataType = DbType.Int32;
                colvarPageType.MaxLength = 0;
                colvarPageType.AutoIncrement = false;
                colvarPageType.IsNullable = true;
                colvarPageType.IsPrimaryKey = false;
                colvarPageType.IsForeignKey = false;
                colvarPageType.IsReadOnly = false;
                
                schema.Columns.Add(colvarPageType);
                
                TableSchema.TableColumn colvarLength = new TableSchema.TableColumn(schema);
                colvarLength.ColumnName = "Length";
                colvarLength.DataType = DbType.Double;
                colvarLength.MaxLength = 0;
                colvarLength.AutoIncrement = false;
                colvarLength.IsNullable = true;
                colvarLength.IsPrimaryKey = false;
                colvarLength.IsForeignKey = false;
                colvarLength.IsReadOnly = false;
                
                schema.Columns.Add(colvarLength);
                
                TableSchema.TableColumn colvarClassCode = new TableSchema.TableColumn(schema);
                colvarClassCode.ColumnName = "ClassCode";
                colvarClassCode.DataType = DbType.String;
                colvarClassCode.MaxLength = 300;
                colvarClassCode.AutoIncrement = false;
                colvarClassCode.IsNullable = true;
                colvarClassCode.IsPrimaryKey = false;
                colvarClassCode.IsForeignKey = false;
                colvarClassCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarClassCode);
                
                TableSchema.TableColumn colvarPages = new TableSchema.TableColumn(schema);
                colvarPages.ColumnName = "Pages";
                colvarPages.DataType = DbType.Int32;
                colvarPages.MaxLength = 0;
                colvarPages.AutoIncrement = false;
                colvarPages.IsNullable = true;
                colvarPages.IsPrimaryKey = false;
                colvarPages.IsForeignKey = false;
                colvarPages.IsReadOnly = false;
                
                schema.Columns.Add(colvarPages);
                
                TableSchema.TableColumn colvarMeasure = new TableSchema.TableColumn(schema);
                colvarMeasure.ColumnName = "Measure";
                colvarMeasure.DataType = DbType.String;
                colvarMeasure.MaxLength = 300;
                colvarMeasure.AutoIncrement = false;
                colvarMeasure.IsNullable = true;
                colvarMeasure.IsPrimaryKey = false;
                colvarMeasure.IsForeignKey = false;
                colvarMeasure.IsReadOnly = false;
                
                schema.Columns.Add(colvarMeasure);
                
                TableSchema.TableColumn colvarColorCode = new TableSchema.TableColumn(schema);
                colvarColorCode.ColumnName = "ColorCode";
                colvarColorCode.DataType = DbType.Int32;
                colvarColorCode.MaxLength = 0;
                colvarColorCode.AutoIncrement = false;
                colvarColorCode.IsNullable = true;
                colvarColorCode.IsPrimaryKey = false;
                colvarColorCode.IsForeignKey = false;
                colvarColorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarColorCode);
                
                TableSchema.TableColumn colvarProductID = new TableSchema.TableColumn(schema);
                colvarProductID.ColumnName = "ProductID";
                colvarProductID.DataType = DbType.Int32;
                colvarProductID.MaxLength = 0;
                colvarProductID.AutoIncrement = false;
                colvarProductID.IsNullable = true;
                colvarProductID.IsPrimaryKey = false;
                colvarProductID.IsForeignKey = false;
                colvarProductID.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductID);
                
                TableSchema.TableColumn colvarProdVersionID = new TableSchema.TableColumn(schema);
                colvarProdVersionID.ColumnName = "ProdVersionID";
                colvarProdVersionID.DataType = DbType.Int32;
                colvarProdVersionID.MaxLength = 0;
                colvarProdVersionID.AutoIncrement = false;
                colvarProdVersionID.IsNullable = false;
                colvarProdVersionID.IsPrimaryKey = false;
                colvarProdVersionID.IsForeignKey = false;
                colvarProdVersionID.IsReadOnly = false;
                
                schema.Columns.Add(colvarProdVersionID);
                
                TableSchema.TableColumn colvarCategoryID = new TableSchema.TableColumn(schema);
                colvarCategoryID.ColumnName = "CategoryID";
                colvarCategoryID.DataType = DbType.Int32;
                colvarCategoryID.MaxLength = 0;
                colvarCategoryID.AutoIncrement = false;
                colvarCategoryID.IsNullable = true;
                colvarCategoryID.IsPrimaryKey = false;
                colvarCategoryID.IsForeignKey = false;
                colvarCategoryID.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryID);
                
                TableSchema.TableColumn colvarSubSectorID = new TableSchema.TableColumn(schema);
                colvarSubSectorID.ColumnName = "SubSectorID";
                colvarSubSectorID.DataType = DbType.Int32;
                colvarSubSectorID.MaxLength = 0;
                colvarSubSectorID.AutoIncrement = false;
                colvarSubSectorID.IsNullable = true;
                colvarSubSectorID.IsPrimaryKey = false;
                colvarSubSectorID.IsForeignKey = false;
                colvarSubSectorID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorID);
                
                TableSchema.TableColumn colvarSectorID = new TableSchema.TableColumn(schema);
                colvarSectorID.ColumnName = "SectorID";
                colvarSectorID.DataType = DbType.Int32;
                colvarSectorID.MaxLength = 0;
                colvarSectorID.AutoIncrement = false;
                colvarSectorID.IsNullable = true;
                colvarSectorID.IsPrimaryKey = false;
                colvarSectorID.IsForeignKey = false;
                colvarSectorID.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorID);
                
                TableSchema.TableColumn colvarBrandID = new TableSchema.TableColumn(schema);
                colvarBrandID.ColumnName = "BrandID";
                colvarBrandID.DataType = DbType.Int32;
                colvarBrandID.MaxLength = 0;
                colvarBrandID.AutoIncrement = false;
                colvarBrandID.IsNullable = true;
                colvarBrandID.IsPrimaryKey = false;
                colvarBrandID.IsForeignKey = false;
                colvarBrandID.IsReadOnly = false;
                
                schema.Columns.Add(colvarBrandID);
                
                TableSchema.TableColumn colvarAdvertiserID = new TableSchema.TableColumn(schema);
                colvarAdvertiserID.ColumnName = "AdvertiserID";
                colvarAdvertiserID.DataType = DbType.Int32;
                colvarAdvertiserID.MaxLength = 0;
                colvarAdvertiserID.AutoIncrement = false;
                colvarAdvertiserID.IsNullable = true;
                colvarAdvertiserID.IsPrimaryKey = false;
                colvarAdvertiserID.IsForeignKey = false;
                colvarAdvertiserID.IsReadOnly = false;
                
                schema.Columns.Add(colvarAdvertiserID);
                
                TableSchema.TableColumn colvarImageName = new TableSchema.TableColumn(schema);
                colvarImageName.ColumnName = "ImageName";
                colvarImageName.DataType = DbType.String;
                colvarImageName.MaxLength = 50;
                colvarImageName.AutoIncrement = false;
                colvarImageName.IsNullable = true;
                colvarImageName.IsPrimaryKey = false;
                colvarImageName.IsForeignKey = false;
                colvarImageName.IsReadOnly = false;
                
                schema.Columns.Add(colvarImageName);
                
                TableSchema.TableColumn colvarAgencyID = new TableSchema.TableColumn(schema);
                colvarAgencyID.ColumnName = "AgencyID";
                colvarAgencyID.DataType = DbType.Int32;
                colvarAgencyID.MaxLength = 0;
                colvarAgencyID.AutoIncrement = false;
                colvarAgencyID.IsNullable = true;
                colvarAgencyID.IsPrimaryKey = false;
                colvarAgencyID.IsForeignKey = false;
                colvarAgencyID.IsReadOnly = false;
                
                schema.Columns.Add(colvarAgencyID);
                
                TableSchema.TableColumn colvarDateAdded = new TableSchema.TableColumn(schema);
                colvarDateAdded.ColumnName = "DateAdded";
                colvarDateAdded.DataType = DbType.DateTime;
                colvarDateAdded.MaxLength = 0;
                colvarDateAdded.AutoIncrement = false;
                colvarDateAdded.IsNullable = false;
                colvarDateAdded.IsPrimaryKey = false;
                colvarDateAdded.IsForeignKey = false;
                colvarDateAdded.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateAdded);
                
                TableSchema.TableColumn colvarDateModified = new TableSchema.TableColumn(schema);
                colvarDateModified.ColumnName = "DateModified";
                colvarDateModified.DataType = DbType.DateTime;
                colvarDateModified.MaxLength = 0;
                colvarDateModified.AutoIncrement = false;
                colvarDateModified.IsNullable = false;
                colvarDateModified.IsPrimaryKey = false;
                colvarDateModified.IsForeignKey = false;
                colvarDateModified.IsReadOnly = false;
                
                schema.Columns.Add(colvarDateModified);
                
                TableSchema.TableColumn colvarBrandCode = new TableSchema.TableColumn(schema);
                colvarBrandCode.ColumnName = "BrandCode";
                colvarBrandCode.DataType = DbType.Int32;
                colvarBrandCode.MaxLength = 0;
                colvarBrandCode.AutoIncrement = false;
                colvarBrandCode.IsNullable = true;
                colvarBrandCode.IsPrimaryKey = false;
                colvarBrandCode.IsForeignKey = false;
                colvarBrandCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarBrandCode);
                
                TableSchema.TableColumn colvarBrandName = new TableSchema.TableColumn(schema);
                colvarBrandName.ColumnName = "BrandName";
                colvarBrandName.DataType = DbType.String;
                colvarBrandName.MaxLength = 255;
                colvarBrandName.AutoIncrement = false;
                colvarBrandName.IsNullable = true;
                colvarBrandName.IsPrimaryKey = false;
                colvarBrandName.IsForeignKey = false;
                colvarBrandName.IsReadOnly = false;
                
                schema.Columns.Add(colvarBrandName);
                
                TableSchema.TableColumn colvarProductCode = new TableSchema.TableColumn(schema);
                colvarProductCode.ColumnName = "ProductCode";
                colvarProductCode.DataType = DbType.Int32;
                colvarProductCode.MaxLength = 0;
                colvarProductCode.AutoIncrement = false;
                colvarProductCode.IsNullable = true;
                colvarProductCode.IsPrimaryKey = false;
                colvarProductCode.IsForeignKey = false;
                colvarProductCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductCode);
                
                TableSchema.TableColumn colvarProductName = new TableSchema.TableColumn(schema);
                colvarProductName.ColumnName = "ProductName";
                colvarProductName.DataType = DbType.String;
                colvarProductName.MaxLength = 255;
                colvarProductName.AutoIncrement = false;
                colvarProductName.IsNullable = true;
                colvarProductName.IsPrimaryKey = false;
                colvarProductName.IsForeignKey = false;
                colvarProductName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProductName);
                
                TableSchema.TableColumn colvarProdVersionCode = new TableSchema.TableColumn(schema);
                colvarProdVersionCode.ColumnName = "ProdVersionCode";
                colvarProdVersionCode.DataType = DbType.Int32;
                colvarProdVersionCode.MaxLength = 0;
                colvarProdVersionCode.AutoIncrement = false;
                colvarProdVersionCode.IsNullable = true;
                colvarProdVersionCode.IsPrimaryKey = false;
                colvarProdVersionCode.IsForeignKey = false;
                colvarProdVersionCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarProdVersionCode);
                
                TableSchema.TableColumn colvarProdVersionName = new TableSchema.TableColumn(schema);
                colvarProdVersionName.ColumnName = "ProdVersionName";
                colvarProdVersionName.DataType = DbType.String;
                colvarProdVersionName.MaxLength = 255;
                colvarProdVersionName.AutoIncrement = false;
                colvarProdVersionName.IsNullable = true;
                colvarProdVersionName.IsPrimaryKey = false;
                colvarProdVersionName.IsForeignKey = false;
                colvarProdVersionName.IsReadOnly = false;
                
                schema.Columns.Add(colvarProdVersionName);
                
                TableSchema.TableColumn colvarSectorCode = new TableSchema.TableColumn(schema);
                colvarSectorCode.ColumnName = "SectorCode";
                colvarSectorCode.DataType = DbType.Int32;
                colvarSectorCode.MaxLength = 0;
                colvarSectorCode.AutoIncrement = false;
                colvarSectorCode.IsNullable = true;
                colvarSectorCode.IsPrimaryKey = false;
                colvarSectorCode.IsForeignKey = false;
                colvarSectorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorCode);
                
                TableSchema.TableColumn colvarSectorName = new TableSchema.TableColumn(schema);
                colvarSectorName.ColumnName = "SectorName";
                colvarSectorName.DataType = DbType.String;
                colvarSectorName.MaxLength = 500;
                colvarSectorName.AutoIncrement = false;
                colvarSectorName.IsNullable = true;
                colvarSectorName.IsPrimaryKey = false;
                colvarSectorName.IsForeignKey = false;
                colvarSectorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSectorName);
                
                TableSchema.TableColumn colvarSubSectorCode = new TableSchema.TableColumn(schema);
                colvarSubSectorCode.ColumnName = "SubSectorCode";
                colvarSubSectorCode.DataType = DbType.Int32;
                colvarSubSectorCode.MaxLength = 0;
                colvarSubSectorCode.AutoIncrement = false;
                colvarSubSectorCode.IsNullable = true;
                colvarSubSectorCode.IsPrimaryKey = false;
                colvarSubSectorCode.IsForeignKey = false;
                colvarSubSectorCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorCode);
                
                TableSchema.TableColumn colvarSubSectorName = new TableSchema.TableColumn(schema);
                colvarSubSectorName.ColumnName = "SubSectorName";
                colvarSubSectorName.DataType = DbType.String;
                colvarSubSectorName.MaxLength = 500;
                colvarSubSectorName.AutoIncrement = false;
                colvarSubSectorName.IsNullable = true;
                colvarSubSectorName.IsPrimaryKey = false;
                colvarSubSectorName.IsForeignKey = false;
                colvarSubSectorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarSubSectorName);
                
                TableSchema.TableColumn colvarCategoryCode = new TableSchema.TableColumn(schema);
                colvarCategoryCode.ColumnName = "CategoryCode";
                colvarCategoryCode.DataType = DbType.Int32;
                colvarCategoryCode.MaxLength = 0;
                colvarCategoryCode.AutoIncrement = false;
                colvarCategoryCode.IsNullable = true;
                colvarCategoryCode.IsPrimaryKey = false;
                colvarCategoryCode.IsForeignKey = false;
                colvarCategoryCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryCode);
                
                TableSchema.TableColumn colvarCategoryName = new TableSchema.TableColumn(schema);
                colvarCategoryName.ColumnName = "CategoryName";
                colvarCategoryName.DataType = DbType.String;
                colvarCategoryName.MaxLength = 255;
                colvarCategoryName.AutoIncrement = false;
                colvarCategoryName.IsNullable = true;
                colvarCategoryName.IsPrimaryKey = false;
                colvarCategoryName.IsForeignKey = false;
                colvarCategoryName.IsReadOnly = false;
                
                schema.Columns.Add(colvarCategoryName);
                
                TableSchema.TableColumn colvarAgencyCode = new TableSchema.TableColumn(schema);
                colvarAgencyCode.ColumnName = "AgencyCode";
                colvarAgencyCode.DataType = DbType.Int32;
                colvarAgencyCode.MaxLength = 0;
                colvarAgencyCode.AutoIncrement = false;
                colvarAgencyCode.IsNullable = true;
                colvarAgencyCode.IsPrimaryKey = false;
                colvarAgencyCode.IsForeignKey = false;
                colvarAgencyCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarAgencyCode);
                
                TableSchema.TableColumn colvarAgencyName = new TableSchema.TableColumn(schema);
                colvarAgencyName.ColumnName = "AgencyName";
                colvarAgencyName.DataType = DbType.String;
                colvarAgencyName.MaxLength = 255;
                colvarAgencyName.AutoIncrement = false;
                colvarAgencyName.IsNullable = true;
                colvarAgencyName.IsPrimaryKey = false;
                colvarAgencyName.IsForeignKey = false;
                colvarAgencyName.IsReadOnly = false;
                
                schema.Columns.Add(colvarAgencyName);
                
                TableSchema.TableColumn colvarAdvertiserCode = new TableSchema.TableColumn(schema);
                colvarAdvertiserCode.ColumnName = "AdvertiserCode";
                colvarAdvertiserCode.DataType = DbType.Int32;
                colvarAdvertiserCode.MaxLength = 0;
                colvarAdvertiserCode.AutoIncrement = false;
                colvarAdvertiserCode.IsNullable = true;
                colvarAdvertiserCode.IsPrimaryKey = false;
                colvarAdvertiserCode.IsForeignKey = false;
                colvarAdvertiserCode.IsReadOnly = false;
                
                schema.Columns.Add(colvarAdvertiserCode);
                
                TableSchema.TableColumn colvarAdvertiserName = new TableSchema.TableColumn(schema);
                colvarAdvertiserName.ColumnName = "AdvertiserName";
                colvarAdvertiserName.DataType = DbType.String;
                colvarAdvertiserName.MaxLength = 255;
                colvarAdvertiserName.AutoIncrement = false;
                colvarAdvertiserName.IsNullable = true;
                colvarAdvertiserName.IsPrimaryKey = false;
                colvarAdvertiserName.IsForeignKey = false;
                colvarAdvertiserName.IsReadOnly = false;
                
                schema.Columns.Add(colvarAdvertiserName);
                
                TableSchema.TableColumn colvarColorName = new TableSchema.TableColumn(schema);
                colvarColorName.ColumnName = "ColorName";
                colvarColorName.DataType = DbType.String;
                colvarColorName.MaxLength = 50;
                colvarColorName.AutoIncrement = false;
                colvarColorName.IsNullable = true;
                colvarColorName.IsPrimaryKey = false;
                colvarColorName.IsForeignKey = false;
                colvarColorName.IsReadOnly = false;
                
                schema.Columns.Add(colvarColorName);
                
                TableSchema.TableColumn colvarInternetBodyName = new TableSchema.TableColumn(schema);
                colvarInternetBodyName.ColumnName = "InternetBodyName";
                colvarInternetBodyName.DataType = DbType.String;
                colvarInternetBodyName.MaxLength = 200;
                colvarInternetBodyName.AutoIncrement = false;
                colvarInternetBodyName.IsNullable = true;
                colvarInternetBodyName.IsPrimaryKey = false;
                colvarInternetBodyName.IsForeignKey = false;
                colvarInternetBodyName.IsReadOnly = false;
                
                schema.Columns.Add(colvarInternetBodyName);
                
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["Adex"].AddSchema("vInternetLog",schema);
            }

        }

        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }

	    #endregion
	    
	    #region .ctors
	    public VInternetLog()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }

        public VInternetLog(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}

			MarkNew();
	    }

	    
	    public VInternetLog(object keyID)
	    {
		    SetSQLProps();
		    LoadByKey(keyID);
	    }

    	 
	    public VInternetLog(string columnName, object columnValue)
        {
            SetSQLProps();
            LoadByParam(columnName,columnValue);
        }

        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("MediaTypeName")]
        public string MediaTypeName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaTypeName");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeName", value);
            }

        }

	      
        [XmlAttribute("MediaName")]
        public string MediaName 
	    {
		    get
		    {
			    return GetColumnValue<string>("MediaName");
		    }

            set 
		    {
			    SetColumnValue("MediaName", value);
            }

        }

	      
        [XmlAttribute("MediaType")]
        public int? MediaType 
	    {
		    get
		    {
			    return GetColumnValue<int?>("MediaTypeCode");
		    }

            set 
		    {
			    SetColumnValue("MediaTypeCode", value);
            }

        }

	      
        [XmlAttribute("InternetLogID")]
        public int InternetLogID 
	    {
		    get
		    {
			    return GetColumnValue<int>("InternetLogID");
		    }

            set 
		    {
			    SetColumnValue("InternetLogID", value);
            }

        }

	      
        [XmlAttribute("CountryID")]
        public byte? CountryID 
	    {
		    get
		    {
			    return GetColumnValue<byte?>("CountryID");
		    }

            set 
		    {
			    SetColumnValue("CountryID", value);
            }

        }

	      
        [XmlAttribute("RFDate")]
        public DateTime? RFDate 
	    {
		    get
		    {
			    return GetColumnValue<DateTime?>("RFDate");
		    }

            set 
		    {
			    SetColumnValue("RFDate", value);
            }

        }

	      
        [XmlAttribute("MediaCode")]
        public int? MediaCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("MediaCode");
		    }

            set 
		    {
			    SetColumnValue("MediaCode", value);
            }

        }

	      
        [XmlAttribute("TimeStart")]
        public int? TimeStart 
	    {
		    get
		    {
			    return GetColumnValue<int?>("TimeStart");
		    }

            set 
		    {
			    SetColumnValue("TimeStart", value);
            }

        }

	      
        [XmlAttribute("TimeEnd")]
        public int? TimeEnd 
	    {
		    get
		    {
			    return GetColumnValue<int?>("TimeEnd");
		    }

            set 
		    {
			    SetColumnValue("TimeEnd", value);
            }

        }

	      
        [XmlAttribute("PageNumber")]
        public int? PageNumber 
	    {
		    get
		    {
			    return GetColumnValue<int?>("PageNumber");
		    }

            set 
		    {
			    SetColumnValue("PageNumber", value);
            }

        }

	      
        [XmlAttribute("InternetBodyCode")]
        public int? InternetBodyCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("InternetBodyCode");
		    }

            set 
		    {
			    SetColumnValue("InternetBodyCode", value);
            }

        }

	      
        [XmlAttribute("Tipology")]
        public string Tipology 
	    {
		    get
		    {
			    return GetColumnValue<string>("Tipology");
		    }

            set 
		    {
			    SetColumnValue("Tipology", value);
            }

        }

	      
        [XmlAttribute("RealCost")]
        public decimal? RealCost 
	    {
		    get
		    {
			    return GetColumnValue<decimal?>("RealCost");
		    }

            set 
		    {
			    SetColumnValue("RealCost", value);
            }

        }

	      
        [XmlAttribute("Wide")]
        public double? Wide 
	    {
		    get
		    {
			    return GetColumnValue<double?>("Wide");
		    }

            set 
		    {
			    SetColumnValue("Wide", value);
            }

        }

	      
        [XmlAttribute("PageType")]
        public int? PageType 
	    {
		    get
		    {
			    return GetColumnValue<int?>("PageType");
		    }

            set 
		    {
			    SetColumnValue("PageType", value);
            }

        }

	      
        [XmlAttribute("Length")]
        public double? Length 
	    {
		    get
		    {
			    return GetColumnValue<double?>("Length");
		    }

            set 
		    {
			    SetColumnValue("Length", value);
            }

        }

	      
        [XmlAttribute("ClassCode")]
        public string ClassCode 
	    {
		    get
		    {
			    return GetColumnValue<string>("ClassCode");
		    }

            set 
		    {
			    SetColumnValue("ClassCode", value);
            }

        }

	      
        [XmlAttribute("Pages")]
        public int? Pages 
	    {
		    get
		    {
			    return GetColumnValue<int?>("Pages");
		    }

            set 
		    {
			    SetColumnValue("Pages", value);
            }

        }

	      
        [XmlAttribute("Measure")]
        public string Measure 
	    {
		    get
		    {
			    return GetColumnValue<string>("Measure");
		    }

            set 
		    {
			    SetColumnValue("Measure", value);
            }

        }

	      
        [XmlAttribute("ColorCode")]
        public int? ColorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ColorCode");
		    }

            set 
		    {
			    SetColumnValue("ColorCode", value);
            }

        }

	      
        [XmlAttribute("ProductID")]
        public int? ProductID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductID");
		    }

            set 
		    {
			    SetColumnValue("ProductID", value);
            }

        }

	      
        [XmlAttribute("ProdVersionID")]
        public int ProdVersionID 
	    {
		    get
		    {
			    return GetColumnValue<int>("ProdVersionID");
		    }

            set 
		    {
			    SetColumnValue("ProdVersionID", value);
            }

        }

	      
        [XmlAttribute("CategoryID")]
        public int? CategoryID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CategoryID");
		    }

            set 
		    {
			    SetColumnValue("CategoryID", value);
            }

        }

	      
        [XmlAttribute("SubSectorID")]
        public int? SubSectorID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SubSectorID");
		    }

            set 
		    {
			    SetColumnValue("SubSectorID", value);
            }

        }

	      
        [XmlAttribute("SectorID")]
        public int? SectorID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectorID");
		    }

            set 
		    {
			    SetColumnValue("SectorID", value);
            }

        }

	      
        [XmlAttribute("BrandID")]
        public int? BrandID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("BrandID");
		    }

            set 
		    {
			    SetColumnValue("BrandID", value);
            }

        }

	      
        [XmlAttribute("AdvertiserID")]
        public int? AdvertiserID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("AdvertiserID");
		    }

            set 
		    {
			    SetColumnValue("AdvertiserID", value);
            }

        }

	      
        [XmlAttribute("ImageName")]
        public string ImageName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ImageName");
		    }

            set 
		    {
			    SetColumnValue("ImageName", value);
            }

        }

	      
        [XmlAttribute("AgencyID")]
        public int? AgencyID 
	    {
		    get
		    {
			    return GetColumnValue<int?>("AgencyID");
		    }

            set 
		    {
			    SetColumnValue("AgencyID", value);
            }

        }

	      
        [XmlAttribute("DateAdded")]
        public DateTime DateAdded 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateAdded");
		    }

            set 
		    {
			    SetColumnValue("DateAdded", value);
            }

        }

	      
        [XmlAttribute("DateModified")]
        public DateTime DateModified 
	    {
		    get
		    {
			    return GetColumnValue<DateTime>("DateModified");
		    }

            set 
		    {
			    SetColumnValue("DateModified", value);
            }

        }

	      
        [XmlAttribute("BrandCode")]
        public int? BrandCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("BrandCode");
		    }

            set 
		    {
			    SetColumnValue("BrandCode", value);
            }

        }

	      
        [XmlAttribute("BrandName")]
        public string BrandName 
	    {
		    get
		    {
			    return GetColumnValue<string>("BrandName");
		    }

            set 
		    {
			    SetColumnValue("BrandName", value);
            }

        }

	      
        [XmlAttribute("ProductCode")]
        public int? ProductCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProductCode");
		    }

            set 
		    {
			    SetColumnValue("ProductCode", value);
            }

        }

	      
        [XmlAttribute("ProductName")]
        public string ProductName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProductName");
		    }

            set 
		    {
			    SetColumnValue("ProductName", value);
            }

        }

	      
        [XmlAttribute("ProdVersionCode")]
        public int? ProdVersionCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("ProdVersionCode");
		    }

            set 
		    {
			    SetColumnValue("ProdVersionCode", value);
            }

        }

	      
        [XmlAttribute("ProdVersionName")]
        public string ProdVersionName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ProdVersionName");
		    }

            set 
		    {
			    SetColumnValue("ProdVersionName", value);
            }

        }

	      
        [XmlAttribute("SectorCode")]
        public int? SectorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SectorCode");
		    }

            set 
		    {
			    SetColumnValue("SectorCode", value);
            }

        }

	      
        [XmlAttribute("SectorName")]
        public string SectorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SectorName");
		    }

            set 
		    {
			    SetColumnValue("SectorName", value);
            }

        }

	      
        [XmlAttribute("SubSectorCode")]
        public int? SubSectorCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("SubSectorCode");
		    }

            set 
		    {
			    SetColumnValue("SubSectorCode", value);
            }

        }

	      
        [XmlAttribute("SubSectorName")]
        public string SubSectorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("SubSectorName");
		    }

            set 
		    {
			    SetColumnValue("SubSectorName", value);
            }

        }

	      
        [XmlAttribute("CategoryCode")]
        public int? CategoryCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("CategoryCode");
		    }

            set 
		    {
			    SetColumnValue("CategoryCode", value);
            }

        }

	      
        [XmlAttribute("CategoryName")]
        public string CategoryName 
	    {
		    get
		    {
			    return GetColumnValue<string>("CategoryName");
		    }

            set 
		    {
			    SetColumnValue("CategoryName", value);
            }

        }

	      
        [XmlAttribute("AgencyCode")]
        public int? AgencyCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("AgencyCode");
		    }

            set 
		    {
			    SetColumnValue("AgencyCode", value);
            }

        }

	      
        [XmlAttribute("AgencyName")]
        public string AgencyName 
	    {
		    get
		    {
			    return GetColumnValue<string>("AgencyName");
		    }

            set 
		    {
			    SetColumnValue("AgencyName", value);
            }

        }

	      
        [XmlAttribute("AdvertiserCode")]
        public int? AdvertiserCode 
	    {
		    get
		    {
			    return GetColumnValue<int?>("AdvertiserCode");
		    }

            set 
		    {
			    SetColumnValue("AdvertiserCode", value);
            }

        }

	      
        [XmlAttribute("AdvertiserName")]
        public string AdvertiserName 
	    {
		    get
		    {
			    return GetColumnValue<string>("AdvertiserName");
		    }

            set 
		    {
			    SetColumnValue("AdvertiserName", value);
            }

        }

	      
        [XmlAttribute("ColorName")]
        public string ColorName 
	    {
		    get
		    {
			    return GetColumnValue<string>("ColorName");
		    }

            set 
		    {
			    SetColumnValue("ColorName", value);
            }

        }

	      
        [XmlAttribute("InternetBodyName")]
        public string InternetBodyName 
	    {
		    get
		    {
			    return GetColumnValue<string>("InternetBodyName");
		    }

            set 
		    {
			    SetColumnValue("InternetBodyName", value);
            }

        }

	    
	    #endregion
    
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string MediaTypeName = @"MediaTypeName";
            
            public static string MediaName = @"MediaName";
            
            public static string MediaType = @"MediaTypeCode";
            
            public static string InternetLogID = @"InternetLogID";
            
            public static string CountryID = @"CountryID";
            
            public static string RFDate = @"RFDate";
            
            public static string MediaCode = @"MediaCode";
            
            public static string TimeStart = @"TimeStart";
            
            public static string TimeEnd = @"TimeEnd";
            
            public static string PageNumber = @"PageNumber";
            
            public static string InternetBodyCode = @"InternetBodyCode";
            
            public static string Tipology = @"Tipology";
            
            public static string RealCost = @"RealCost";
            
            public static string Wide = @"Wide";
            
            public static string PageType = @"PageType";
            
            public static string Length = @"Length";
            
            public static string ClassCode = @"ClassCode";
            
            public static string Pages = @"Pages";
            
            public static string Measure = @"Measure";
            
            public static string ColorCode = @"ColorCode";
            
            public static string ProductID = @"ProductID";
            
            public static string ProdVersionID = @"ProdVersionID";
            
            public static string CategoryID = @"CategoryID";
            
            public static string SubSectorID = @"SubSectorID";
            
            public static string SectorID = @"SectorID";
            
            public static string BrandID = @"BrandID";
            
            public static string AdvertiserID = @"AdvertiserID";
            
            public static string ImageName = @"ImageName";
            
            public static string AgencyID = @"AgencyID";
            
            public static string DateAdded = @"DateAdded";
            
            public static string DateModified = @"DateModified";
            
            public static string BrandCode = @"BrandCode";
            
            public static string BrandName = @"BrandName";
            
            public static string ProductCode = @"ProductCode";
            
            public static string ProductName = @"ProductName";
            
            public static string ProdVersionCode = @"ProdVersionCode";
            
            public static string ProdVersionName = @"ProdVersionName";
            
            public static string SectorCode = @"SectorCode";
            
            public static string SectorName = @"SectorName";
            
            public static string SubSectorCode = @"SubSectorCode";
            
            public static string SubSectorName = @"SubSectorName";
            
            public static string CategoryCode = @"CategoryCode";
            
            public static string CategoryName = @"CategoryName";
            
            public static string AgencyCode = @"AgencyCode";
            
            public static string AgencyName = @"AgencyName";
            
            public static string AdvertiserCode = @"AdvertiserCode";
            
            public static string AdvertiserName = @"AdvertiserName";
            
            public static string ColorName = @"ColorName";
            
            public static string InternetBodyName = @"InternetBodyName";
            
	    }

	    #endregion
    }

}

